TfrxBDEQuery

The component is used for performing SQL-queries to DB. The component has the following properties:

Property Description
Active Defines whether a query is active.
DatabaseName DB alias name.
FieldAliases Allows to set user’s field aliases.
Filter Expression for records’ filtering.
Filtered Defines whether it is necessary to use the filter.
Master Data master-set.
Params The list of query parameters.
SQL Query text.

The "Active," "DatabaseName," "FieldAliases," "Filter," "Filtered," and "Master" properties are similar to the properties of the "TfrxBDETable" component described above. The "SQL" property has its own editor for filling the SQL-query.

The "Params" property also has its editor. It becomes available as soon as a query text contains parameters.

A parameter can be of two types: either one assigned from the master-source or one having a concrete value (either an absolute symbol or a link to the variable or object’s property, as it is shown in the picture, can act as a value).

In case when a parameter is taken from the data master-set, it is necessary to adjust the "TfrxBDEQuery.Master" property. The data set must contain a field with the name coinciding with the name of the parameter. At the same time, it is necessary to specify neither a parameter type, nor its value.